package com.pxl.springbootinit.mapper;

import com.pxl.springbootinit.model.dto.task.TaskReviewForm;
import com.pxl.springbootinit.model.entity.TaskReview;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.pxl.springbootinit.model.vo.TaskReviewVO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author MADAO
* @description 针对表【task_review(任务评价表)】的数据库操作Mapper
* @createDate 2024-12-20 11:59:03
* @Entity com.pxl.springbootinit.model.entity.TaskReview
*/
public interface TaskReviewMapper extends BaseMapper<TaskReview> {

    List<TaskReviewVO> selectTaskReview(TaskReviewForm taskReviewForm, int start, int end);

    @Select("SELECT count(*) from task t join task_review tr on t.id = tr.task_id;")
    Long countTaskReview(TaskReviewForm taskReviewForm);
}




